EMT Practice Test

1. Question Content...

---

Question1: Certification Aid wants to create a file drop automation with a filename pattern. An import file is placed daily on the Marketing Cloud Enhanced FTP server, and the file name always starts with the current month and day (e.g. OCT26). How should the filename pattern be defined? Choose 2.

Question2: A developer is leveraging the SOAP API to dynamically display Profile and Preference Attributes in a custom profile center. Which method could be used to support the dynamic functionality?

Question3: A developer wants to build an audience by identifying subscribers who opened a specific email. Which query should the developer use?

Question4: Customer data has been imported into a staging data extension and needs to be normalized before adding into the master data extension. A text field named 'birthday' contains date values in various formats. Some of the values are valid dates, but some are not.
Which SQL keywords and functions could be used to write the query'' Choose 2 answers

Question5: A developer wants to programmatically inject Contacts into a journey via REST API. What is the recommended route using POST data extension fields and values?

Question6: A developer created an email with AMPscript variable as the subject line. The subject line variable was recently updated, but when testing the email, the wrong subject line continues to appear in the inbox. The developer thinks another, outdated, subject line variable is declared within the email. Where could the outdated variable be located?

Question7: Which of the following statements are correct concerning Contacts and Subscribers? Choose 2.

Question8: Which two ways would a developer write an Exclusion Script to exclude sending an email at send time when comparing against a Boolean field in the Sendable Data Extension?
Choose 2 answers

Question9: A developer is building an integration with the Marketing Cloud API. Which configuration should be used for the API integration component in the associated Installed Package?

Question10: A developer receives Error Code 5 when performing a SOAP API call. The error states: "Cannot Perform 'Post' on objects of type 'SentEvent'".
What could be the issue?

Question11: Certification Aid wants to automate the import of zipped files into a Data Extension. The zip files are placed on the Marketing Cloud Enhanced FTP server every night. Which activity is needed before those files can be imported? Choose 1.

Question12: A developer used LookupRows to retrieve data when building a dynamic email.
What should be the next step before using this rowset within a FOR loop?

Question13: A developer wants to upload a base64-encoded file to Content Builder using an API Installed Package but receives an insufficient Privileges error. What should the developer check to troubleshoot the error?

Question14: A developer needs to use the 'contacts/ route of the REST API to update records in a data extension.
What should the developer verify before making the API call?

Question15: NTO is using a mobile campaign to collect an email addresses of interested subscribers. Using AMPscript's API functions they will send a confirmation email when an email is texted into their short code. Which two objects are required to successfully create a TriggerSend object? Choose 2

Question16: Certification Aid sends an email to a newly imported List with Subscribers who have no associated Subscriber Key. Which value will become the Contact Key? Choose 1.

Question17: A developer wants to create a CloudPage which is linked from an email. %%[SET @point = RequestParameter(x) SET @value = 5 IF Length(@point) > 1 THEN SET @value = 1 ELSEIF Length(@point)>2 THEN SET @value = 2 ELSEIF Length(@point) >3 THEN SET@value = 3 ELSEIF Length(@point) >4 THEN SET @value = 4 ENDIF]%% Which is the expected value of @value if x = 'Tacos'?

Question18: The Contact Delete feature can be used within an Enterprise 2.0 account from which business unit?

Question19: A developer is troubleshooting why a parent-level data extension cannot be accessed by a child business unit.
What should the developer check to validate the data available can be accessed for child business unit queries?

Question20: Which two AMPscript HTTP functions allow an OAuth token to be passed in a header?
Choose 2 answers

Question21: When appending data to links via Web Analytics Connector, which parameter should be used to track subscriber behavior?

Question22: A marketer from Cloud Kicks wants to make sure no email from their welcome journey gets sent to their competitor at Rainbow Run.
Which two best practices should the developer use when setting up the Send Email Activity in the welcome journey?
Choose 2 answers

Question23: A developer needs to display a value which has been calculated using an AMPscript block. This value is stored in the variable named 'Label'.
Which two ways should the developer display this value in the body of an email? Choose 2 answers

Question24: A developer identified duplicate contacts and initiated a Contact Delete process for 10 million subscribers. How could the process be expedited?

Question25: A marketer is troubleshooting why an email send's tracking information is not available in Sales Cloud. The marketer confirms Marketing Cloud Connect is installedproperly. What should be confirmed next to continue troubleshooting the send's tracking information?

Question26: A developer wants CloudPages to work with a REST API returning data in JavaScript Object Notation. The developer wants to efficiently ingest the data and write it to a data extension.
Which function should be used?

Question27: Northern Trail Outfitters' legal team is concerned about the daily import process that brings in subscribers to a Sendable Data Extension, even when records have already been targeted for deletion.
Which two true expected behaviors for these records occur in the event a send is initiated directly to this Sendable Data Extension?
Choose 2 answers

Question28: A developer needs to determine why a Query Activity in an Automation has failed.
Which three scenarios could have caused this? Choose 3 answers

Question29: What is the operational order of the Contact Delete process for Marketing Cloud?

Question30: Certification Aid wants to encrypt data stored in Marketing Cloud. It is fine if unencrypted fields are visible to Marketing Cloud and Salesforce users, but the underlying data should be encrypted at rest to prevent physical data theft. Which encryption method should be chosen? Choose 1.

Question31: An email requires custom AMPscript to append the subscriber's zip code to a link in the email. A field name zipcode already exist in the sending data extension. Its important Marketing Cloud tracks subscribers who click on the link. Which two AMPscript functions should be used in the setup? Choose

Question32: NTO is reconsidering the requirement to have English, Spanish and French versions of their email campaigns. They request a developer to create a query which aggregates clicks grouped by language of the recipient. Language is stored in a Profile Attribute. Which two Data Views would be included in the query? Choose 2 answer

Question33: A developer identified a use case where a triggered send of an email is needed. The developer already successfully set up authentication with a Client ID and Client Secret has used them in several REST calls. When the REST call is made, a "401 Unauthorized" error is returned. What is the first thing the developer should check?

Question34: How many month of data can a developer query from the tracking data views (_Sent, _Open, _Click)?

Question35: A developer wants to implement a newsletter registration from on NTO's website. Prior to form submission, an email address provided by the visitor should be validated. Which option could be used to support this scenario?

Question36: A company need to retrieve a large number of rows from a DE via the API. Which two solutions would optimize the performance? Choose 2

Question37: Which of the following is a valid comment within an AMPscript code block? Choose 1.

Question38: A developer wants to create an HTML table where rows will alternate background colors between white and red. The developer does not know how many rows will be sent within each email, and decides to use a loop and assigns the RowCount() of the table rows to the variable @numerator. What is the recommended AMPscript logic to determine the background color of each table row within the loop?

Question39: Which programming language should be used in email messages? Choose 1.

Question40: A developer needs to process a payload from an external system in a CloudPage.
What Marketing Cloud Server-Side JavaScript Platform function should be used for converting a string payload in JSON format to a JavaScript object?

Question41: A developer wants to inject a Contact into a journey using API. What method and route would be used to accomplish this?

Question42: A developer needs to configure a process that can store encrypted data from Marketing Cloud as a file on an external server. What steps should the developer take?

Question43: Clock Kicks would like to encrypt and store form data submitted from a CloudPage in a data extension using AMPscript. Which three encryption options could be used when creating a new key in Key Management? Choose 3

Question44: A developer wants to use the Marketing Cloud SOAP API to retrieve which subscribers were sent a particular email. Which SOAP API object should be used?

Question45: A developer receives a request to integrate Marketing Cloud with a lead capture tool. The lead capture tool will call the Marketing Cloud API to create a data extension every time a new lead form is published. The created data extension's name should match the name of the form exactly.
Which API feature could the developer use to dynamically create these data extensions?

Question46: A developer is creating a CloudPage which accepts secure parameters via an email link and will submit those parameters to another CloudPage for data upsert. The page currently captures an Appointment ID parameter passed into it and sets the value to the variable caapptld. The developer does NOT want the Appointment ID to be visible to anyone using the form.
What is the best method to ensure the parameters are passed successfully to the data upsert page?

Question47: NTO wants use Personally Identifiable Information (PII) data to personalize email communications, but does not want to store PII data in Marketing Cloud. Which feature could they use to personalize emails from an external data source?

Question48: A developer wants to create a data model in Contact Builder.
Which two applications will be able to use this newly-created data model for segmentation?
Choose 2 answers

Question49: A developer is creating a custom preference center and wants to log unsubscribe events from the CloudPage. Which set of parameters should be captured and provided to the LongUnsubEvent Execute Call to ensure accurate unsubscribe information?

Question50: A developer initiated a batch delete of Contacts in Contact Builder due to an import error during implementation. There are over two million records that need to be deleted.
Which two factors should be considered when batch deleting large volumes of contacts?Choose 2 answers

Question51: Northtrn Trail Outfitters (NTO) wants to import a data file. It will be uploaded at regular intervals to their Enhanced FTP Account where an automation will import the file Into a data extension. NTO requires the file to be encrypted.
Which two file encryption options are supported when importing data files to Marketing Cloud?
Choose 2 answers

Question52: A developer uses an API to send data to a Marketing Cloud data extension once every five minutes using the REST API. They notice data does not always write to the data extension, leading to data loss.
Which three best practices are recommended to avoid this issue? Choose 3 answers

Question53: Certification Aid created following AMPscript code: %%[ SET @var1 = 10 SET @var2 = 20 SET @var3 = 30 ]%% How can the three variables be summed up to evaluate to 60? Choose 1.

Question54: How can SSJS variables be referenced for content personalization? Choose 1.

Question55: A developer wants to include a comment within an AMPscript code block for the benefit of other developers who will be reviewing the code.
Which syntax should the developer use?

Question56: Certification Aid wants to import data from a CSV file into a Data Extension. The CSV file contains all relevant dat a. New records should be added to the Data Extension, and records which are not in the file should be removed from the Data Extension. Which import operation should be chosen for this? Choose 1.

Question57: A developer needs to write AMPscript to ensure the expiration date on a coupon is the last day of the month. What would produce the desired result?

Question58: Landing pages can use which SSJS library? 1. Core LibraryZ. Platform Library 3. SSJS Library

Question59: Northern Trail Outfitters' account is configured with two child BU(s): US and Global. The account has a data extension In the Shared Data Extensions folder named 'MemberData'. This data extension contains basic address information, as well as Boolean fields labeled 'US' and 'Global' indicating to which business unit the subscriber belongs. Automation needs to be created in the US business unit to query all records in New York who are members of the business unit US.
SELECT * FROM MemberData WHERE State = 'NY' AND US = 1
What would cause this query to report the following error: "An error occurred while checking the query syntax. Errors: MemberData is not a known data extension or system data view. You can only query existing data extensions or system data views."?

Question60: NTO wants to trigger a receipt email via the SOAP API whenever a customer makes a purchase. Their developer wrote the call using the TriggerSendDefinition object and the Create method, but no emails have been sent during his initial testing. Which object and method should the developer use?

Question61: A developer wants to transform the date and time 'Data_Enrolled' from Daylight Savings time. How would the developer change the time to fall back one hour?

Question62: Northern Trail Outfitters is using a mobile campaign to collect email addresses of interested subscribers. Using AMPScript's API functions they will send a confirmation email when an email is texted into their short code.
Which two objects are required to successfully create a TriggeredSend object? Choose 2 answers

Question63: NTO uses an external CRM which only exports encrypted files. NTO's marketing manager team wants to use some of the subscriber data found in the CRM for future marketing sends. Which three actions should be included in an automation given these requirements? Choose 3

Question64: A developer needs to configure an Email Send Logging Data Extension for a new business unit. Which option should be used?

Question65: A developer wants to trigger an SMS message to a subscriber using a form published on CloudPages. How should the SMS message be triggered once the subscriber submits the form?

Question66: Northern Trails Outfitters (NTO) has a sendable data extension with 1,500,000 contact records they want to delete.
Which step is required before deleting the contacts?

Question67: NTO wants to exclude sends to specific subscribers based on a business rule, which is defined in an Exclusion Script. Which three types of sends would support this functionality? Choose 3

Question68: A marketing director at Northern Trail Outfitters wants to analyze the Send, Click, and Open Data Views. Which activities should the developer build to generate the data before transferring it to the SFTP?

Question69: Northern Trails Outfitters (NTO) developers want to use the Transactional Messaging API to send email receipts to customers.
What is the first step required to send using the API?